KeyFinder: An Efficient Minimal Keys Finding Algorithm For Relational Databases
نویسندگان
چکیده
In relational databases, it is essential to know all minimal keys since the concept of database normaliza-tion based on and functional dependencies a relation schema. Existing algorithms for determining keysor computing closure arbitrary sets attributes are generally time-consuming. this paper we present anefficient algorithm, called KeyFinder, solving key-ï¬nding problem. We also propose more direct methodfor set attributes. KeyFinder powerful proof procedure ï¬ndingkeys tableaux. Experimental results show that outperforms its predecessors in terms searchspace execution time.
منابع مشابه
Relational Databases Query Optimization using Hybrid Evolutionary Algorithm
Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...
متن کاملRelational Databases in RDF: Keys and Foreign Keys
Today, most of the data on the web resides in relational databases. To make the data available for the semantic web mappings into RDF can be used. Such mappings should preserve the information about the structure of keys and foreign keys, because otherwise important semantic information is lost. In this paper, we discuss several possible ways to map relational databases into an RDF graph. We di...
متن کاملError-Correcting Keys in Relational Databases
Suppose that the entries of a relational database are collected in an unreliable way, that is the actual database may differ from the true database in at most one data of each individual. An error-correcting key is such a set of attributes, that the knowledge of the actual data of an individual in this set of attributes uniquely determines the individual. It is showed that if the minimal keys a...
متن کاملThe Number of Keys in Relational and Nested Relational Databases
Thalheim, B., The number of keys in relational and nested relational databases, Discrete Applied Mathematics 40 (1992) 265-282. Combinatorial propositions, concerning the maximal number of minimal keys are considered. It is shown that the results of Demetrovics about the maximal number of minimal keys on unbounded domains do not hold for finite domains. Using this result lower bounds for the si...
متن کاملFinding Minimal Keys in a Relation Instance
Mannila 11] cites as an open problem in Data Mining the problem of nding all minimal keys in a relation instance using only time that is polynomial in the number of relation attributes and number of minimal keys and sub-quadratic in the size of the relation instance. This paper investigates the eecacy of an \A Priori"-type approach to the problem, applied simultaneously in a level-wise top-down...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Inteligencia artificial
سال: 2021
ISSN: ['1988-3064', '1137-3601']
DOI: https://doi.org/10.4114/intartif.vol24iss68pp37-52